home *** CD-ROM | disk | FTP | other *** search
/ PC Pro 2000 August / DPPCPRO0800.ISO / August / Simply / _SETUP.1 / Leaver Analysis Query.tpl < prev    next >
Encoding:
Text File  |  1997-09-19  |  1.2 KB  |  136 lines
  1. ###SIMPLY-QUERY TEMPLATE FILE###
  2. 0
  3. 0
  4. 1
  5. YES
  6. NO
  7. [KeyFields]
  8. Key Fields
  9. [Employee]
  10. [empid]
  11. Employee ID
  12. 1
  13. 0
  14. 2
  15. YES
  16. NO
  17. [Employee]
  18. Employee Details
  19. [Employee]
  20. [Surname]
  21. Surname
  22. 1
  23. 0
  24. 3
  25. YES
  26. NO
  27. [Employee]
  28. Employee Details
  29. [Employee]
  30. [Firstname]
  31. Firstname
  32. 1
  33. 0
  34. 5
  35. YES
  36. NO
  37. [Employee]
  38. Employee Details
  39. [Employee]
  40. [title]
  41. Title
  42. 1
  43. 0
  44. 82
  45. YES
  46. NO
  47. [Employee]
  48. Employee Details
  49. [Employee]
  50. [DeptCode]
  51. Department Code
  52. 1
  53. 0
  54. 81
  55. YES
  56. NO
  57. [Employee]
  58. Employee Details
  59. [Employee]
  60. [LocCode]
  61. Location Code
  62. 0
  63. 0
  64. 30
  65. YES
  66. NO
  67. [Employee]
  68. Employee Details
  69. [Employee]
  70. [left]
  71. Left Employment?
  72. 2
  73. 0
  74. 31
  75. YES
  76. NO
  77. [Employee]
  78. Employee Details
  79. [Employee]
  80. [dateleft]
  81. Date Left Employment
  82. 1
  83. 0
  84. 32
  85. YES
  86. NO
  87. [Employee]
  88. Employee Details
  89. [Employee]
  90. [leavereas]
  91. Reason For Leaving
  92. 1
  93. 0
  94. 33
  95. YES
  96. NO
  97. [Employee]
  98. Employee Details
  99. [Employee]
  100. [leavenotes]
  101. Leaving Notes
  102. 0
  103. 0
  104. 34
  105. YES
  106. NO
  107. [Employee]
  108. Employee Details
  109. [Employee]
  110. [reemploy]
  111. Re Employ?
  112. ###
  113. Employee ID
  114. !!NONE!!
  115. Surname
  116. !!NONE!!
  117. Firstname
  118. !!NONE!!
  119. Title
  120. !!NONE!!
  121. Department Code
  122. !!NONE!!
  123. Location Code
  124. !!NONE!!
  125. Left Employment?
  126. = TRUE
  127. Date Left Employment
  128. !!NONE!!
  129. Reason For Leaving
  130. !!NONE!!
  131. Leaving Notes
  132. !!NONE!!
  133. Re Employ?
  134. !!NONE!!
  135. ###
  136.